include 'header.php';
$r = @mysql_fetch_object(mysql_query("SELECT
event.dag as dag,
event.tijd as tijd,
locatie.naam as cafenaam,
locatie.web as cafeweb,
locatie.hyves as cafehyves,
locatie.facebook as facebook,
locatie.myspace as cafemyspace,
locatie.youtube as cafeyoutube,
locatie.twitter as cafetwitter,
locatie.adres as adres,
locatie.telefoon as telefoon,
event.opmerking as opmerking,
locatie.eten as eten,
locatie.drinken as drinken,
locatie.slapen as slapen,
band.naam as bandnaam,
band.website as bandweb,
band.hyves as bandhyves,
band.facebook as bandfacebook,
band.myspace as bandmyspace,
band.youtube as bandyoutube,
band.twitter as bandtwitter,
band.tagline as tagline
FROM
event,locatie,band
WHERE
event.id='".$_GET['id']."'
AND event.cafe=locatie.id
AND event.band=band.id
"
));
$i=1;
$nietcompleet=0;
echo '
';
if ($r->dag==1) echo "donderdag";
if ($r->dag==2) echo "vrijdag";
echo '
'."\n";
echo '';
echo '
'.$r->cafenaam.'
'."\n";
echo '
'.$r->adres.', '.$r->telefoon.'
'."\n";
echo '
'."\n";
if (($r->cafeweb!="") && ($r->cafeweb!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if (($r->cafehyves!="") && ($r->cafehyves!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if (($r->cafefacebook!="") && ($r->cafefacebook!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if (($r->cafemyspace!="") && ($r->cafemyspace!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if (($r->cafeyoutube!="") && ($r->cafeyoutube!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if ($r->cafetwitter!="") { echo '
'."\n"; } else { echo '
'."\n"; }
if ($r->eten=="1") { echo '
'."\n"; } else { echo '
'."\n"; }
if ($r->drinken=="1") { echo '
'."\n"; } else { echo '
'."\n"; }
if ($r->slapen=="1") { echo '
'."\n"; } else { echo '
'."\n"; }
echo '
'."\n";
echo '
'.$r->tijd.''."\n";
echo '
'.$r->bandnaam.''."\n";
echo '
'.$r->tagline;
if ($r->tagline!="") echo "
";
echo $r->opmerking.'
'."\n";
echo '
'."\n";
if (($r->bandweb!="") && ($r->bandweb!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if (($r->bandhyves!="") && ($r->bandhyves!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if (($r->bandfacebook!="") && ($r->bandfacebook!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if (($r->bandmyspace!="") && ($r->bandmyspace!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if (($r->bandyoutube!="") && ($r->bandyoutube!="http://")) { echo '
'."\n"; } else { echo '
'."\n"; }
if ($r->bandtwitter!="") { echo '
'."\n"; } else { echo '
'."\n"; }
echo '
'."\n";
include 'footer.php';
?>